// Load the http module to create an http server.
//var http = require('http');

var mysql = require('mysql');
var connection = mysql.createConnection({
  host     : 'jdbc:mysql://localhost:3306/themafiagame?zeroDateTimeBehavior=convertToNull',
  user     : 'root',
  password : ''
});

connection.connect(function(err) {
  // connected! (unless `err` is set)
});

//var post  = {id: 1, title: 'Hello MySQL'};
//var query = connection.query('INSERT INTO posts SET ?', post, function(err, result) {
//  // Neat!
//});
//console.log(query.sql); // INSERT INTO posts SET `id` = 1, `title` = 'Hello MySQL'

//// Configure our HTTP server to respond with Hello World to all requests.
//var server = http.createServer(function (request, response) {
//  response.writeHead(200, {"Content-Type": "text/plain"});
//  response.end("Hello World\n");
//});
//
//// Listen on port 8000, IP defaults to 127.0.0.1
//server.listen(8000);
//
//// Put a friendly message on the terminal
//console.log("Server running at http://127.0.0.1:8000/");